Purpose |
Create an output in Excel format with addition of new fields for EMEA commercial invoice |
Release No |
001 |
Submitted on |
05/10/2016 |
Submitted by |
Deepak Yasam |
Environment |
NECNED to NECNEQ |
Sent To |
Rizwan Shah |
Object(s) created by |
Prudvi Mandadi/Deepak Yasam |
Object(s) tested by |
Surya/Deepak/Siba |
Transport Status |
Created in NECNED100 |
Sl. |
Transport ID |
Description |
Object Name |
1 |
NEDK934587 |
SD:22066:New TVARVC variable for EMEA Comm.Inv Excel |
TVARVC |
2 |
NEDK933706 |
SD:22066:Program for EMEA Comm.In Excel for Inb&Out Del |
ZSF00010_EMEA_IB_OB |
3 |
NEDK934583 |
SD:22066:Program for EMEA Comm.In Excel for PO |
ZMM_PO_PRINT_EXCEL |
4 |
NEDK934585 |
SD:22066:ZECO EMEA Comm.Inv Excel output |
VN_T685B V_T683_XX SAPscript Text |
Test ID |
Test Scenario |
Expected Result |
SO |
PO |
OBD |
P/F |
Notes |
Tested By |
QA By |
SD-001 |
1. Create ZOR order 2. Create Delivery w/o PGI 3. Issue ZECO output manually |
The items should be displayed in the commercial invoice form though PGI is not done. |
1949144 |
NA |
82071929 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-002 |
1.Create ZOR order with three items 2. Create Delivery and PGI two items 3. Issue ZECO output manually |
Only the PGI items should be displayed in the commercial invoice form. |
1949143 |
NA |
82071928 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-003 |
1.Create ZOR order and partially reject few lines 2. Create Delivery and PGI 3. Issue ZECO output manually |
Only the PGI items should be displayed in the commercial invoice form. |
1949145 |
NA |
82071930 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-004 |
1. Create ZOR order with Item category TAB 2. Create PO, Delivery and PGI 3. Issue ZECO output manually |
Only the PGI items should be displayed in the commercial invoice form. |
1949146 |
4500105024 |
82071931 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-005 |
1.Create ZPTO order 2. Create PO, Delivery and PGI 3.Issue ZECO output manually |
Only the PGI items should be displayed in the commercial invoice form. |
1949147 |
4500105025 |
82071932 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
Test ID |
Test Scenario |
Expected Result |
SO |
PO |
IBD |
P/F |
Notes |
Tested By |
QA By |
SD-001 |
1.Create ZU3P SO in 2000,10,00 sales area and corresponding SNC PO. 2. Create Inb.Del document and PGR. 3.Execute ZECO output manullay. |
All the items in the Inb del should be displayed in the commercial invoice form. |
1949108 |
4500105014 |
180011846 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-002 |
1.Create two ZU3P SO's in 2000,10,00 sales area and corresponding single PO. 2. Create Inb.Del document and PGR. 3.Execute ZECO output manually. |
All the items in the Inb del should be displayed in the commercial invoice form. |
1949109 1949110 |
4500105015 |
180011847 180011848 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-003 |
1.Create ZU3P SO in 2000,10,00 sales area and multiple SNC PO's. 2. Create Inb.Del documents and PGR. 3.Execute ZECO output manullay in each IB Delivery. |
All the items in the Inb del's should be displayed in the commercial invoice form. |
1949111 |
4500105016 4500105017 |
180011849 180011850 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-004 |
1.Create ZU3P SO in 2000,10,00 sales area and corresponding SNC PO. 2. Create Inb.Del for partial items and PGR. 3.Execute ZECO output manullay. |
All the items in the Inb del's should be displayed in the commercial invoice form. |
1949112 |
4500105018 |
180011851 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-005 |
1.Create ZU3P SO in 2000,10,00 sales area and corresponding SNC PO. 2. Create Inb.Del document and do not PGR. 3.Execute ZECO output manullay. |
The items shouldn't be displayed in the commercial invoice form as the PGR is not done. |
1949113 |
4500105019 |
180011852 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-006 |
1.Create two ZU3P SO's in 2000,10,00 sales area and corresponding single PO. 2. Create Inb.Del document and do not PGR. 3.Execute ZECO output manually. |
The items shouldn't be displayed in the commercial invoice form as the PGR is not done. |
1949114 1949115 |
4500105020 |
180011853 180011854 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-007 |
1.Create ZU3P SO in 2000,10,00 sales area and multiple SNC PO's. 2. Create Inb.Del document and do not PGR. 3.Execute ZECO output manullay in each IB Delivery. |
The items shouldn't be displayed in the commercial invoice form as the PGR is not done. |
1949116 |
4500105021 4500105022 |
180011855 180011856 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-008 |
1. Create ZU3P SO in 2000,10,00 sales area and reject 1st size of each size. Then create corresponding SNC PO. 2. Create inb. Del document and do the PGR. 3. Execute ZECO output manually in each IB Delivery. |
Items should be displayed in the commercial invoice form as the PGR is done with correct unit price and total price. |
1949153 |
4500105026 |
180011857 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
Test ID |
Test Scenario |
Expected Result |
SO |
PO |
MIGO/ INB DEL. |
P/F |
Notes |
Tested By |
QA By |
SD-001 |
1.Create ZPTO SO in 2000,10,00 sales area and corresponding NB PO. 2. Create MIGO document for all the items in the PO. 3.Execute ZECO output manullay in PO. |
All the PGR items should be displayed in the commercial form and PO (Po type- NB) number should not be displayed. |
1949095 |
4500105001 |
5000385211 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-002 |
1.Create two ZPTO SO's in 2000,10,00 sales area and corresponding single NB PO. 2. Create MIGO document for all the items in the PO. 3.Execute ZECO output manually in PO. |
All the PGR items should be displayed in the commercial form and PO (Po type- NB) number should not be displayed. Multiple output files should be triggered for each SO. |
1949096 1949097 |
4500105002 |
5000385212 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-003 |
1.Create ZPTO SO in 2000,10,00 sales area and multiple NB PO's. 2. Create MIGO document for all the items in the PO's. 3.Execute ZECO output manullay in each PO. |
All the PGR items should be displayed in the commercial formand PO (Po type- NB) number should not be displayed. |
1949098 |
4500105003 4500105004 |
5000385213 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-004 |
1.Create ZPTO SO in 2000,10,00 sales area and corresponding NB PO. 2. Create MIGO document for partial items in the PO. 3.Execute ZECO output manullay in PO. |
All the PGR items should be displayed in the commercial form Non PGR items shouldn't be displayed. and PO (Po type- NB) number should not be displayed. |
1949099 |
4500105005 |
5000385214 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-005 |
1.Create two ZPTO SO's in 2000,10,00 sales area and corresponding single NB PO. 2. Create MIGO document for partial items in PO. 3.Execute ZECO output manually in PO. |
All the PGR items should be displayed in the commercial form Non PGR items shouldn't be displayed. and PO (Po type- NB) number should not be displayed. Multiple output files should be triggered for each SO. |
1949100 1949101 |
4500105006 |
5000385215 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-006 |
1.Create ZPTO SO in 2000,10,00 sales area and multiple NB PO's. 2. Create MIGO document for partial items in the PO's. 3.Execute ZECO output manullay in each PO |
All the PGR items should be displayed in the commercial form Non PGR items shouldn't be displayed. and PO (Po type- NB) number should not be displayed. |
1949102 |
4500105007 4500105008 |
5000385216 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-007 |
1.Create ZPTO SO in 2000,10,00 sales area and corresponding NB PO. 2. MIGO document is not created for the PO. 3.Execute ZECO output manullay in PO. |
The items shouldn't be displayed as there is no receipt quantity and PO (Po type- NB) number should not be displayed. |
1949103 |
4500105009 |
NA |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-008 |
1.Create two ZPTO SO's in 2000,10,00 sales area and corresponding single NB PO. 2. MIGO document is not created for the PO. 3.Execute ZECO output manually in PO. |
The items shouldn't be displayed as there is no receipt quantity and PO (Po type- NB) number should not be displayed. Multiple output files should be triggered for each SO. |
1949104 1949105 |
4500105010 |
NA |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-009 |
1.Create ZPTO SO in 2000,10,00 sales area and multiple NB PO's. 2. MIGO document is not created for the PO. 3.Execute ZECO output manullay in each PO |
The items shouldn't be displayed as there is no receipt quantity and PO (Po type- NB) number should not be displayed. |
1949106 |
4500105011 4500105012 |
NA |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-010 |
1.Create ZPTO SO in 2000,10,00 sales area and corresponding NB PO. 2. MIGO document is not created for the PO. 3.Execute ZECO output manullay in PO. |
The items shouldn't be displayed as there is no receipt quantity and PO (Po type- NB) number should not be displayed. |
1949107 |
4500105013 |
NA |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-011 |
1.Create ZPTO SO in 2000,10,00 sales area and Reject 1st size of each item and create corresponding NB PO. 2. Create MIGO document for all the items in the PO's. 3.Execute ZECO output manullay in PO. |
All the PGR items should be displayed in the commercial form with correct unit price and total price and PO (Po type- NB) number should not be displayed. |
1949154 |
4500105027 |
5000385228 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-012 |
1.Create ZU3P SO in 2000,10,00 sales area and corresponding SNC PO. 2. Create Inb.Del document and PGR. 3.Execute ZECO output manullay in PO. |
All the items in the Inb del should be displayed in the commercial invoice form. |
1949108 |
4500105014 |
180011846 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-013 |
1.Create two ZU3P SO's in 2000,10,00 sales area and corresponding single PO. 2. Create Inb.Del document and PGR. 3.Execute ZECO output manually in PO. |
All the items in the Inb del should be displayed in the commercial invoice form. Multiple output files should be triggered for each SO. |
1949109 1949110 |
4500105015 |
180011847 180011848 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-014 |
1.Create ZU3P SO in 2000,10,00 sales area and multiple SNC PO's. 2. Create Inb.Del documents and PGR. 3.Execute ZECO output manullay in each PO. |
All the items in the Inb del's should be displayed in the commercial invoice form. |
1949111 |
4500105016 4500105017 |
180011849 180011850 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-015 |
1.Create ZU3P SO in 2000,10,00 sales area and corresponding SNC PO. 2. Create Inb.Del for partial items and PGR. 3.Execute ZECO output manullay in PO. |
All the items in the Inb del's should be displayed in the commercial invoice form. |
1949112 |
4500105018 |
180011851 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-016 |
1.Create ZU3P SO in 2000,10,00 sales area and corresponding SNC PO. 2. Create Inb.Del document and do not PGR. 3.Execute ZECO output manullay in PO. |
The items shouldn't be displayed in the commercial invoice form as the PGR is not done. |
1949113 |
4500105019 |
180011852 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-017 |
1.Create two ZU3P SO's in 2000,10,00 sales area and corresponding single PO. 2. Create Inb.Del document and do not PGR. 3.Execute ZECO output manually in PO. |
The items shouldn't be displayed in the commercial invoice form as the PGR is not done. Multiple output files should be triggered for each SO. |
1949114 1949115 |
4500105020 |
180011853 180011854 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-018 |
1.Create ZU3P SO in 2000,10,00 sales area and multiple SNC PO's. 2. Create Inb.Del document and do not PGR. 3.Execute ZECO output manullay in each PO. |
The items shouldn't be displayed in the commercial invoice form as the PGR is not done. |
1949116 |
4500105021 4500105022 |
180011855 180011856 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-019 |
1. Create ZU3P SO in 2000,10,00 sales area and reject 1st size of each size. Then create corresponding SNC PO. 2. Create inb. Del document and do the PGR. 3. Execute ZECO output manually in PO. |
Items should be displayed in the commercial invoice form as the PGR is done with correct unit price and total price. |
1949153 |
4500105026 |
180011857 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-020 |
1. Create multiple ZU3P SO in 2000,10,00 sales area and Then create corresponding Z3NB PO with confirmation ZNEC. 2. Create MIGO document 3. Execute ZECO output manually in PO. |
The items shouldn't be displayed in the commercial invoice form as the MIGO is not done. Multiple output files should be triggered for each SO. |
1949167 1949168 |
4500105029 |
NA |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-021 |
1. Create multiple ZU3P SO in 2000,10,00 sales area and Then create corresponding Z3NB PO with confirmation ZNEC. 2. Create MIGO document 3. Execute ZECO output manually in PO. |
All the items in the PO should be displayed in the commercial invoice form. Multiple output files should be triggered for each SO. |
1949169 1949170 |
4500105030 |
5000385230 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-022 |
1. Create multiple ZU3P SO in 2000,10,00 sales area and Then create corresponding Z3NB PO with confirmation ZNEC. 2. Create MIGO document with partial qty. 3. Execute ZECO output manually in PO. |
All MIGO'ed items in the PO should be displayed in the commercial invoice form. Multiple output files should be triggered for each SO. |
1949182 1949183 |
4500105031 |
5000385231 |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-023 |
1. Create PO (PO Type- NB) without any reference of Sales order. 2. Don't create MIGO document 3. Execute the ZECO output manually in PO. |
Output should be triggered with blank excel sheet. |
NA |
4500105033 |
NA |
P |
NA |
Deepak/Siba |
Deepak Yasam |
SD-024 |
1. Create PO (PO Type- NB) without any reference of Sales order. 2. Create MIGO document. 3. Execute the ZECO output manually in PO. |
Output should be triggered with blank excel sheet. |
NA |
4500105034 |
5000385232 |
P |
NA |
Deepak/Siba |
Deepak Yasam |